namespace Ample.DAL
{
    using System;
    using System.Data.Linq;
    using System.Data.Linq.Mapping;
    using System.Data;
    using System.Collections.Generic;
    using System.Reflection;
    using System.Linq;
    using System.Linq.Expressions;

    partial class AmpleDataContext
    {
        [Function(Name = "dbo.AMPLE_Orders_Select")]
        public ISingleResult<Ample.Model.Order> AMPLE_Orders_SelectManual()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<Ample.Model.Order>)(result.ReturnValue));
        }

        [Function(Name = "dbo.AMPLE_Orders_Select_By_OrderId")]
        public ISingleResult<Ample.Model.Order> AMPLE_Orders_Select_By_OrderIdManual([Parameter(Name = "OrderId", DbType = "Int")] System.Nullable<int> orderId)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), orderId);
            return ((ISingleResult<Ample.Model.Order>)(result.ReturnValue));
        }
        [Function(Name = "dbo.AMPLE_OrderItems_Select")]
        public ISingleResult<Ample.Model.OrderItem> AMPLE_OrderItems_SelectManual()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<Ample.Model.OrderItem>)(result.ReturnValue));
        }

        [Function(Name = "dbo.AMPLE_OrderStatuses_Select")]
        public ISingleResult<Ample.Model.OrderStatus> AMPLE_OrderStatuses_SelectManual()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<Ample.Model.OrderStatus>)(result.ReturnValue));
        }

        [Function(Name = "dbo.Ample_Products_Select")]
        public ISingleResult<Ample.Model.Product> Ample_Products_SelectManual()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<Ample.Model.Product>)(result.ReturnValue));
        }

        [Function(Name = "dbo.Ample_Products_Select_By_ProductId")]
        public ISingleResult<Ample.Model.Product> Ample_Products_Select_By_ProductIdManual([Parameter(Name = "ProductId", DbType = "Int")] System.Nullable<int> productId)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), productId);
            return ((ISingleResult<Ample.Model.Product>)(result.ReturnValue));
        }

        [Function(Name = "dbo.Ample_Products_Select_By_ProductTypeId")]
        public ISingleResult<Ample.Model.Product> Ample_Products_Select_By_ProductTypeIdManual([Parameter(Name = "ProductTypeId", DbType = "Int")] System.Nullable<int> productTypeId)
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), productTypeId);
            return ((ISingleResult<Ample.Model.Product>)(result.ReturnValue));
        }

        [Function(Name = "dbo.Ample_ProductTypes_Select")]
        public ISingleResult<Ample.Model.ProductType> Ample_ProductTypes_SelectManual()
        {
            IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
            return ((ISingleResult<Ample.Model.ProductType>)(result.ReturnValue));
        }
    }
}
